﻿/*dùng để đổ dữ liệu cũ sang bảng tblHBLExchange*/
delete from tblHBLExchange
go
insert into tblHBLExchange
	SELECT h.ID_HBL,f.ID_Currency,h.Ratio
	FROM tblHBL h, tblFile f, tblFileMBL mbl
	WHERE h.ID_FileMBL=mbl.ID_FileMBL
	and mbl.ID_File = f.ID_File
	order by h.ID_HBL
go